I would be very very interested! L

Ok, the download and instructions is available here
http://jensine.web.surftown.dk/dashboard_getmembersingroups/bpumbdashboarddownload.aspx

Let me know if you encounter any problems.

Tommy

Tommy -

Brilliant! Unfortunately I'm getting the following error on V4 RC2 with MySQL:

Event code: 3005
Event message: An unhandled exception has occurred.
...
Exception information:
Exception type: ArgumentException
Exception message: Keyword not supported: 'datalayer'.
...
Stack trace: at System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey)
at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules)
at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)
at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
at System.Data.SqlClient.SqlConnection.ConnectionStringSet(String value)
at System.Data.SqlClient.SqlConnection.setConnectionString(String value)
at System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments)
at System.Web.UI.WebControls.ListControl.OnDataBinding(EventArgs e)
...

Let me know if you have time to address.

Thanks,
-Paul

Paul, I'm just trying to install v4 RC2 on mysql myself, so if I succeed I will take a look at it immediately.

Tommy

Hi Tommy,

Seems you are directly using SQL Server (Paul's error indicates that). If you go through the datalayer, it will work.

Cheers,

Ruben

[quote=Ruben]Hi Tommy,

Seems you are directly using SQL Server (Paul's error indicates that). If you go through the datalayer, it will work.

Cheers,

Ruben[/quote]


I think you are right Ruben - I fix it when I get my MySQL site up and running.

Tommy

I wonder if the other dashboard extensions are using the datalayer - e.g. the member search (or are they not available for V4) ?

- Ruben, do I have to make specific v3 and v4 versions, or is it possible to make one common version. It seems as if the SqlHelper was introduced in v4 (I suppose thats what I need - in my current v3 solution I use the Microsoft.ApplicationBlocks.Data SqlHelper class, just like in the dashboard member search control)

Tommy

I've made a v4-specific version, but I'm awaiting my host to do some security fixes so I haven't been able to test it yet.
It is on its way, though...

Tommy

Ruben (or whoever interested), I get this exception:

[code][ArgumentException: Keyword not supported: 'datalayer'.]
System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey) +1481474
System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules) +102
System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) +52
...[/code]

when trying my dashboard member component on v4RC3 MySQL. I'm specifically using your MySQL datalayer dll (I had to copy into the RC3 to get the installation working)
I use this datalayer call to handle my sql-query text string

[code]...
IRecordsReader dr = umbraco.BusinessLogic.Application.SqlHelper.ExecuteReader(sql);
DataGrid1.DataSource = dr;
...[/code]

Am I doing it the wrong way, or what could be the issue here?

Tommy

Ok, it's always easier to blame others persons for your own faults. Sorry guys.
My exception was due to a sql-server specific databind.

Anyways, now I got a v4 RC3 compatible version which works for MySQL (and hopefully also MSSQL Server)

Its available here
http://jensine.web.surftown.dk/dashboard_getmembersingroups/bpumbdashboarddownload-v4-.aspx


Let me know if you have any problems using it

Tommy

Excellent Tommy, it's exactly what I needed (you came just at the right time!).

BTW, I'm running it on v3.0.6 - no problems at all!

Thanks,
- Lee

Tommy -

Hmm...still getting the " Exception message: Keyword not supported: 'datalayer'."

Just guessing, since I'm only looking at the assembly in Reflector, that this statement isn't compatible with the Umbraco DataLayer:

[code]...
this.SqlDataSource1.ConnectionString = GlobalSettings.DbDSN;
...[/code]


Thanks,
-Paul

Hi Paul, thanks for your response. I checked it out, and apparently I included the wrong dll. Try the v4rc3 version again - I uploaded a new version.

- I hope it works now.

Tommy

Tommy -

Great, that's the right assembly. I think you may still have the old .ascx file in the archive as well. Once I removed:

[code]...
DataSourceID="SqlDataSource1"
...[/code]

from MemberGroupListBox, and

[code]...
onselecting="SqlDataSource1_Selecting"
...[/code]
from SqlDataSource1 all looks good.

Thanks for sharing.
-Paul

Thanks Paul, its now corrected.

Tommy

New download locations:

V3:
http://blackpoint.dk/umbraco-workbench.aspx?Snippet=/umbraco-workbench/packages/bpumbdashboard,-v3.aspx

and

V4:
http://blackpoint.dk/umbraco-workbench.aspx?Snippet=/umbraco-workbench/packages/bpumbdashboard,-v4.aspx

Tommy

The instructions don't work quite right as I had to place the user control into the /usercontrols directory for it to work. But other than that....Bravo.

As an asside I met with my users last week and they said wouldn't it be great if you could see which members were in which groups. I said "Surely someone in the world has done that before...thats why Umbraco is great"

Sure enough, someone had done it before, and with about 20mins of effort I was able to meet my customers requirements.

Umbraco and the community is great.

pmarden, I'm glad you can use it.
Let me know if you have additional comments or ideas.

I'll review the installation instruction tonight - thanks for letting me know

Tommy

I updated the installation instructions - note that the BP.Umb.Dashboard folder now goes into the /usercontrols folder.

Tommy

is working on a reply...